/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://106.75.33.59/teach?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username itcast_edu_stu \
--password itcast_edu_stu \
--query "select * ,'2022-12-14' as dt from tbh_student_signin_record where 1=1 and signin_date between '2019-08-31 00:00:00' and '2019-09-01 23:59:59' and \$CONDITIONS" \
--hcatalog-database ole_ods \
--hcatalog-table ole_ods_tbh_student_signin_record \
-m 1

/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://106.75.33.59/teach?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username itcast_edu_stu \
--password itcast_edu_stu \
--query "select *,'2022-12-14' as dt from  tbh_class_time_table where 1=1 and create_time between '2019-08-31 00:00:00' and '2019-09-01 23:59:59' and \$CONDITIONS" \
--hcatalog-database ole_ods \
--hcatalog-table ole_ods_tbh_class_time_table \
-m 1


/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://106.75.33.59/teach?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username itcast_edu_stu \
--password itcast_edu_stu \
--query "select *,'2022-12-14' as dt from  student_leave_apply where 1=1 and create_time between '2019-08-16 00:00:00' and '2019-09-02 23:59:59' and \$CONDITIONS" \
--hcatalog-database ole_ods \
--hcatalog-table ole_ods_student_leave_apply \
-m 1


/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://106.75.33.59/teach?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username itcast_edu_stu \
--password itcast_edu_stu \
--query "select *,'2022-12-14' as dt from course_table_upload_detail where 1=1 and  \$CONDITIONS" \
--hcatalog-database ole_ods \
--hcatalog-table ole_ods_course_table_upload_detail \
-m 1


/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://106.75.33.59/teach?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username itcast_edu_stu \
--password itcast_edu_stu \
--query "select *,'2022-12-14' as dt from class_studying_student_count where 1=1 and  \$CONDITIONS" \
--hcatalog-database ole_ods \
--hcatalog-table ole_ods_class_studying_student_count \
-m 1